![]() |
![]() |
![]() |
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() |
![]() |
![]() |
To access the contents, click the chapter and section titles.
Oracle Performance Tuning and Optimization
Multimedia SystemsMultimedia systems have slightly different criteria about what a well-tuned system is. In a data-processing environment, slight interruptions in response times are hardly noticed. In video and audio processing, a slight interruption in the constant stream of data is very noticeable. Therefore, in a multimedia environment, response times and ensuring a constant stream of data are the highest priorities. Shipping SystemsSome applications in the shipping industry have such transient data that backups may not be significant. Consider a database that contains tracking information for packages that are picked up, moved around the country, and then delivered. In the time it takes to do a backup of this system, the data for a particular package may no longer be in the database. If a hardware failure occurs, by the time the system is back online and data is restored, perhaps none of the items in the database are of any use. For such systems, it may be more important to configure for fault tolerance. The system can be tuned for maximum throughput with less emphasis on tuning for backup and recovery. Of course, account information must be backed up in any event. This type of application is a candidate for a fault-tolerant system such as the Oracle Parallel Server or the Oracle Standby Database feature available in Oracle version 7.3. SummaryThis chapter looked at several different types of systems, each of which has different criteria for being well tuned. A system that is well tuned for client/server applications may not be the best-tuned system for batch processing. However, there is a commonality: in each case, you want to make sure that individual components such as disks and networks are not slowing down the system processing. Another important factor in a well-tuned system is the ability to handle peak events. If the load on the system is increasedcaused by an unusually high number of users or an event such as a system backup or a checkpointthe system should still be able to process transactions at nearly the same rate as during the typical system load. You will have slightly different criteria for what you consider a well-tuned system depending on your needs. The following chapters discuss how to tune the system to get the results you want.
|
![]() |
Products | Contact Us | About Us | Privacy | Ad Info | Home
Use of this site is subject to certain Terms & Conditions, Copyright © 1996-2000 EarthWeb Inc. All rights reserved. Reproduction whole or in part in any form or medium without express written permission of EarthWeb is prohibited. |